package com.zhuiyun.pm.sys.homePage.mapper;

import com.zhuiyun.pm.client.home.pojo.ClientAnnouncement;
import com.zhuiyun.pm.client.home.pojo.dto.ClientAnnouncementDTO;
import com.zhuiyun.pm.config.BaseMapper;
import com.zhuiyun.pm.sys.homePage.entity.SysChartEntity;
import com.zhuiyun.pm.sys.homePage.entity.dto.BarChartDTO;
import com.zhuiyun.pm.sys.homePage.entity.dto.PieChartDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.poi.ss.usermodel.charts.ScatterChartData;

import java.util.List;
import java.util.Map;

/**
 *
 * @author: HKY
 * @date: 2023/3/21 16:47
 * @Description: 主页数据分析
 */
@Mapper
public interface HomePageMapper extends BaseMapper<SysChartEntity> {

    /**
     *
     * @author: HKY
     * @date: 2023/3/21 16:48
     * @return java.util.List
     * @Description: 柱状图
     */
    List<BarChartDTO> getBarChart(@Param(value = "sqlStr")String sqlStr);

    /**
     *
     * @author: HKY
     * @date: 2023/3/21 16:48
     * @return java.util.List
     * @Description: 饼状图
     */
    List<PieChartDTO> getPieChart(@Param(value = "sqlStr")String sqlStr);

}
